Data Mart Schema Construction from Object Oriented Databases
نویسندگان
چکیده
This paper proposes a bottom-up method that helps designers of decision support systems to construct data mart schemas based on an object database. Our method extracts the database schema from the repository of the object DBMS in order to work on the most recent version of the transactional system’s data model. It then applies a set of rules to identify facts, measures, dimensions and their attributes, all of which it organizes as star schemas. The obtained star schemas could be used to help decision makers expressing their analytical needs. In addition, being identified from objects of the transactional system, they carry information useful in the ETL definition phase.
منابع مشابه
Construction graphique d'entrepôts et de magasins de données
Nowadays, decisional systems have became a significant research topic in databases. Data warehouses and data marts are the main elements of such systems. This paper presents our decisional support system. We present graphical interfaces which help the administrator to build data warehouses and data marts. We present a data warehouse building interface based on an object-oriented conceptual mode...
متن کاملSchema Refinement and Schema Integration in Object-oriented Databases Schema Reenement and Schema Integration in Object-oriented Databases
This report presents a formal approach to support schema integration in object-oriented databases. The basis of the approach is a synthetic subclass order to compare classes. Classes are integrated in a natural way using a join operator w.r.t. the subclass order. In contrast with existing literature, our subclass order compares classes not only by their attributes, but also by the behaviour of ...
متن کاملTwo-Way Mapping between Object-Oriented Databases and XML
This paper presents a novel approach for mapping an existing object-oriented database into XML and vice versa. The major motivation to carry out this study is the fact that it is necessary to facilitate platform independent exchange of the content of object oriented databases and the need to store XML in a structured database. There are more common features between the object-oriented model and...
متن کاملTemporal Object-Oriented Data Model for the Schema Modification
A temporal database management system is being considered as an important DBMS in new database applications such as engineering databases, VLSI, and CAD. Much researche on temporal databases, temporal query languages and temporal modeling techniques have been proposed. However, thus researche has not considered the schema modification problem in a temporal database yet. In this paper, we propos...
متن کاملFormal transformation of spatiotemporal data from object-oriented database to XML
With the rapid development of the Internet, XML (Extensible Markup Language) is increasingly gaining acceptance as a medium for integrating and exchanging data. Meanwhile, object-oriented database has a strong ability to store data, XML can benefit greatly and specifically from database support and object-oriented database management system. Consequently, it is significant to exchange data from...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2009